<?php if ( ! defined('ABS_PATH')) exit('ABS_PATH is not loaded. Direct access is not allowed.');

    /*
     *      OSCLass – software for creating and publishing online classified
     *                           advertising platforms
     *
     *                        Copyright (C) 2010 OSCLASS
     *
     *       This program is free software: you can redistribute it and/or
     *     modify it under the terms of the GNU Affero General Public License
     *     as published by the Free Software Foundation, either version 3 of
     *            the License, or (at your option) any later version.
     *
     *     This program is distributed in the hope that it will be useful, but
     *         WITHOUT ANY WARRANTY; without even the implied warranty of
     *        MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
     *             GNU Affero General Public License for more details.
     *
     *      You should have received a copy of the GNU Affero General Public
     * License along with this program.  If not, see <http://www.gnu.org/licenses/>.
     */


    class LatestSearches extends DAO {

        private static $instance ;

        public static function newInstance() {
            if(!self::$instance instanceof self) {
                self::$instance = new self ;
            }
            return self::$instance ;
        }

        public function getTableName() { return DB_TABLE_PREFIX . 't_latest_searches'; }

        public function getSearches($limit = 20) {
            return $this->conn->osc_dbFetchResults("SELECT d_date, s_search, COUNT(s_search) as i_total FROM %st_latest_searches GROUP BY s_search ORDER BY d_date DESC LIMIT %s", DB_TABLE_PREFIX, $limit);
        }

        public function getSearchesByDate($time = null) {
            if($time==null) { $time = time() - (7*24*3600); };
            return $this->conn->osc_dbFetchResults("SELECT d_date, s_search, COUNT(s_search) as i_total FROM %st_latest_searches WHERE d_date >= '%s' GROUP BY s_search ORDER BY d_date DESC", DB_TABLE_PREFIX, date('Y-m-d H:i:s', $time));
        }

        public function purgeDate($date = null) {
            if($date!=null) {
                return $this->delete(array(DB_CUSTOM_COND => 'd_date <= '.$date));
            }
        }

        public function purgeNumber($number = null) {
            if($number!=null) {
                $last = $this->conn->osc_dbFetchResult('SELECT * FROM %st_latest_searches ORDER BY d_date DESC LIMIT %d,1', DB_TABLE_PREFIX, $number);
                return $this->delete(array(DB_CUSTOM_COND => "d_date <= '".$last['d_date']."'"));
            }
        }

    }

?>